0. Injestion

Note: first wave infection data are highly untrustable due to poor testing procedure

1. EDA

The protection of the elderly starts to show his effects: few months after the start of the vaccination campaigne, the IC death rate started to decrease, with a 15% drop. The hope is to see a greater decrease after the total vaccination of all people with an age greater than 60 yo.

C:\Users\TTOMMA~1\AppData\Local\Temp/ipykernel_10236/790608759.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  y20['days_since_start'] = diff_dates(pd.to_datetime(start_20), pd.to_datetime(y20.index), days = True)
C:\Users\TTOMMA~1\AppData\Local\Temp/ipykernel_10236/790608759.py:6: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  y21['days_since_start'] = diff_dates(pd.to_datetime(start_21), pd.to_datetime(y21.index), days = True)
C:\Users\TTOMMA~1\AppData\Local\Temp/ipykernel_10236/790608759.py:7: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  y22['days_since_start'] = diff_dates(pd.to_datetime(start_22), pd.to_datetime(y22.index), days = True)

VACCINATION IS WORKING !!!!!

Nowdays excess of deaths respect to the same period of 2020 is crearly explained by this plot: the first re-opening was made with about 750 ICU patients, while the second re-opening was made with almost 3000 ICU patients. By now, the number of ICU patients is more than double last year.